| |
You have selected Trial Membership for the following services : |
Sorry! This login name is already exists. Please try again
";
exit;
}
}
if($other2 != "") { $ot = "$other2" ; } else { $ot = "" ; }
$count=count($segments);
//THis for other segments
for ($i=0; $i<$count; $i++) {
$seg .= "$segments[$i]".",";
}
//THis for other activity
$act = $activity." ,".$ot;
//echo $segments;
$insert_query = "insert into `ynfx_revamp`.`ynfx_storefront_enquiry`
( `id` , `login` , `company` , `subject` , `message` , `activity` , `segments` , `companyname` , `contactperson` , `designation` , `address1` , `address2` , `city` , `state` , `zip` , `country` , `telephone` , `cell` , `fax` , `email` , `website` , `about` , `enqdate` , `status` , `comment` , `commentdate` ) values
('', '$login', '$for_company','$subject','$message','$act', '$seg','$company', '$person', '$designation', '$add1','$add2',
'$city','$zip','$state','$country','$tel','$cell', '$fax', '$email','$website','$abt_comp',CURRENT_DATE(),'', '', '0000-00-00')";
$insert = mysql_query($insert_query);
if($insert) {
$insert_id = mysql_insert_id();
$plan_query = "insert into `ynfx_revamp`.`plan_trail` values('','$insert_id','$plan')";
$plan_res = mysql_query($plan_query);
$pass = crypt($password1,substr($password2,0,2));
if($login_validation == 'show') {
//insert as a free member
$mem_insert = "insert into `ynfx_revamp`.`member_corporate`
( `id` , `companyname` , `contactperson` , `title` , `address1` , `address2` , `city` , `state` , `zip` , `country` ,
`telephone` , `fax` , `email` , `website` , `regdate`, `login`, `password`,`about`,`status`,`plan`,`newmember`)
values
('', '$company','$person', '$designation', '$add1', '$add2', '$city','$state','$zip', '$country', '$tel', '$fax',
'$email', '$website','$current_date','$loginname','$pass','$abt_comp','Underprocess_new','free','Y')";
$mem_res = mysql_query($mem_insert);
$member_insert_query = "insert into `ynfx_revamp`.`member`
(`id`, `companyname`, `contactperson`, `title`, `address1`, `address2`, `city`, `state`, `zip`, `country`, `telephone`,
`fax`, `email`, `website`, `regdate`, `login`, `password`, `about`,`plan`, `status`, `newmember`, `newsletter`)
values
('', '$company','$person', '$designation', '$add1', '$add2', '$city','$state','$zip', '$country', '$tel', '$fax',
'$email', '$website','$current_date','$loginname','$password','$abt_comp','free','Approved','Y','Y')";
$res_member_query = mysql_query($member_insert_query);
/*if($mem_res) {
echo "Success";
} else {
echo "Error";
echo mysql_error();
}*/
$trail_mess = "
New member registration received - $person from Trial Membership
Member login information
=========================================
Login : $loginname
Password : $password2
=========================================
Kind regards,
YarnsandFibers Admin";
//mail("[email protected]","New member registration from Trial membership",$trail_mess,"From: [email protected]");
//mail("[email protected]","New member registration from Trial membership",$trail_mess,"From: [email protected]");
mail("[email protected]","New member registration from Trial membership",$trail_mess,"From: [email protected]");
}
//echo $insert_query;
if($profile) {
$update_sel = "update member set `companyname` ='$company', `contactperson` ='$person', `address1` ='$add1', `address2` ='$add2', `city` ='$city', `state` ='$state', `zip` ='$zip', `country` ='$country', `telephone` ='$tel', `fax` ='$fax', `email` ='$email', `website` = '$website', `about` = '$abt_comp' where `login` = '$login'";
$update = mysql_query($update_sel);
//if($update) {echo $update_sel; } else echo mysql_error();
}
$sub = "Trial Membership Request on YarnsandFibers";
$message1= "
Dear Sir/Madam,
Thank you for your interest in Trial Membership on YarnsandFibers.
Your Trial Request for $plan is under review.
Our team will be in touch with you shortly.
Best Regards,
Team YarnsandFibers
==========================================
http://www.YarnsandFibers.com
Tel : +9122 2282 5252
Fax: +9122 2202 3563
==========================================
";
$message2= "
Dear Sir,
Infomration about the user who is interested ".$for_company."
Person name : ".$person."
Member : ".$mem."
Plan : ".$plan."
Subject : ".$subject."
Message : ".$message."
Company name : ".$company."
Designation : ".$designation."
Telephone No : ".$tel."
Fax : ".$fax."
Cell : ".$cell."
Email : ".$email."
Website : ".$website."
Activity : ".$activity."
Segments : ".$seg.$ot."
About Company : ".$abt_comp."
Address :
".
$add1." ".$add2."
".
$city."-".$zip."
".
$state."
".
$country."
"."
Best Regards,
Team YarnsandFibers
==========================================
http://www.YarnsandFibers.com
Tel : +9122 2282 5252
Fax: +9122 2202 3563
==========================================
";
$header = "From: [email protected]\r\n";
$to1 = "$email";
$to2= "[email protected]";
$mail1 = mail($to1,$sub,$message1,$header);
sleep(1);
$header1 = $header . "Cc: [email protected],[email protected]\r\n";
$mail2 = mail($to2,$sub,$message2,$header1);
sleep(1);
if($mail1 && $mail2 ) {
//echo "Mail sent";
echo "
Thank you for your interest in Trial Membership Request on YarnsandFibers.
Our team will be in touch with you shortly.
Best Regards,
Team YarnsandFibers
==========================================
http://www.YarnsandFibers.com
Tel : +91 22 6629 1000
Fax: +91 22 2202 3563
==========================================
";
} else {
echo "Error while sending mail";
echo mysql_error();
}
?>
|
|
|
|
|
|
Since, you are not registered member, please fill the followng form
|
|
|
|
|
|
|
